

USE [T2Logging]
		

		IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
		begin
		EXEC [T2Logging].[dbo].[sp_fulltext_database] @action = 'enable'
		end
		GO

		ALTER DATABASE [T2Logging] SET ANSI_NULL_DEFAULT Off 
		GO

		ALTER DATABASE [T2Logging] SET ANSI_NULLS Off 
		GO

		ALTER DATABASE [T2Logging] SET ANSI_PADDING Off 
		GO

		ALTER DATABASE [T2Logging] SET ANSI_WARNINGS Off 
		GO

		ALTER DATABASE [T2Logging] SET ARITHABORT Off 
		GO

		ALTER DATABASE [T2Logging] SET AUTO_CLOSE On 
		GO

		ALTER DATABASE [T2Logging] SET AUTO_CREATE_STATISTICS On 
		GO

		ALTER DATABASE [T2Logging] SET AUTO_SHRINK Off 
		GO

		ALTER DATABASE [T2Logging] SET AUTO_UPDATE_STATISTICS Off 
		GO

		ALTER DATABASE [T2Logging] SET CURSOR_CLOSE_ON_COMMIT Off 
		GO

		--ALTER DATABASE [T2Logging] SET CURSOR_DEFAULT  Off 
		--GO

		ALTER DATABASE [T2Logging] SET CONCAT_NULL_YIELDS_NULL Off 
		GO

		ALTER DATABASE [T2Logging] SET NUMERIC_ROUNDABORT Off 
		GO

		ALTER DATABASE [T2Logging] SET QUOTED_IDENTIFIER Off 
		GO

		ALTER DATABASE [T2Logging] SET RECURSIVE_TRIGGERS Off 
		GO

		--ALTER DATABASE [T2Logging] SET  DISABLE_BROKER 
		--GO

		ALTER DATABASE [T2Logging] SET AUTO_UPDATE_STATISTICS_ASYNC Off 
		GO

		ALTER DATABASE [T2Logging] SET DATE_CORRELATION_OPTIMIZATION Off 
		GO

		ALTER DATABASE [T2Logging] SET TRUSTWORTHY Off 
		GO

		ALTER DATABASE [T2Logging] SET ALLOW_SNAPSHOT_ISOLATION Off 
		GO

		--ALTER DATABASE [T2Logging] SET PARAMETERIZATION Off 
		--GO

		ALTER DATABASE [T2Logging] SET READ_COMMITTED_SNAPSHOT Off 
		GO

		--ALTER DATABASE [T2Logging] SET HONOR_BROKER_PRIORITY Off 
		--GO

		ALTER DATABASE [T2Logging] SET  READ_WRITE 
		GO

		--ALTER DATABASE [T2Logging] SET RECOVERY Off 
		--GO

		ALTER DATABASE [T2Logging] SET  MULTI_USER 
		GO

		ALTER DATABASE [T2Logging] SET PAGE_VERIFY CHECKSUM  
		GO

		ALTER DATABASE [T2Logging] SET DB_CHAINING Off 
		GO
